inherited frmPurRequestBill: TfrmPurRequestBill
  Left = 420
  Top = 150
  Caption = #35831#36141#21333
  PixelsPerInch = 96
  TextHeight = 12
  inherited pnlDBCtrl: TPanel
    object Shape: TShape [0]
      Left = 313
      Top = 0
      Width = 99
      Height = 36
      Anchors = [akTop, akRight]
      Brush.Color = 16773345
      Pen.Color = clRed
      Pen.Style = psInsideFrame
      Pen.Width = 2
      Shape = stEllipse
    end
    object FinishedLabel: TLabel [1]
      Left = 329
      Top = 8
      Width = 66
      Height = 21
      Anchors = [akTop, akRight]
      Caption = #24050#23436#25104
      Font.Charset = GB2312_CHARSET
      Font.Color = clBlue
      Font.Height = -21
      Font.Name = #23435#20307
      Font.Style = [fsBold]
      ParentFont = False
      Transparent = True
    end
    inherited pnlThirdtrade: TPanel
      inherited lblTTtraderid: TcxLabel
        AnchorX = 78
      end
      inherited cxLabel1: TcxLabel
        Left = 216
        ExplicitLeft = 216
        AnchorX = 244
      end
      inherited lblTTBalanceid: TcxLabel
        Left = 381
        ExplicitLeft = 381
        AnchorX = 433
      end
    end
    inherited lblName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited imgCheck: TcxImage
      Left = 64
      Top = 8
      ExplicitLeft = 64
      ExplicitTop = 8
    end
    inherited imgAbate: TcxImage
      Left = 160
      Top = 20
      ExplicitLeft = 160
      ExplicitTop = 20
    end
    inherited lblPrinted: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited dynlblCreate_by: TcxLabel
      AnchorX = 221
    end
    inherited dynlblCheck_by: TcxLabel
      AnchorX = 429
    end
    inherited dynlblFilid: TcxLabel
      AnchorX = 88
    end
    inherited dynlblDeptid: TcxLabel
      AnchorX = 301
    end
    inherited dynlblEmpid: TcxLabel
      AnchorX = 505
    end
    inherited dynlblBKind: TcxLabel
      AnchorX = 149
    end
  end
  inherited Panel1: TPanel
    inherited labFuncName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited labFuncDesc: TcxLabel
      Style.IsFontAssigned = True
    end
  end
  inherited pnlBottom: TPanel
    inherited lblDepotQty: TcxLabel
      Style.IsFontAssigned = True
    end
  end
  inherited cxStyleRepository1: TcxStyleRepository
    PixelsPerInch = 96
    inherited cxGridBandedTableViewStyleSheet1: TcxGridBandedTableViewStyleSheet
      BuiltIn = True
    end
  end
  inherited cdsDetail: TClientDataSet
    FieldDefs = <
      item
        Name = 'bid'
        DataType = ftInteger
      end
      item
        Name = 'bno'
        DataType = ftInteger
      end
      item
        Name = 'borderno'
        DataType = ftInteger
      end
      item
        Name = 'depotid'
        DataType = ftInteger
      end
      item
        Name = 'productid'
        DataType = ftInteger
      end
      item
        Name = 'cprice'
        DataType = ftFloat
      end
      item
        Name = 'bprice'
        DataType = ftFloat
      end
      item
        Name = 'bquantity'
        DataType = ftFloat
      end
      item
        Name = 'amount'
        DataType = ftFloat
      end
      item
        Name = 'unitid'
        DataType = ftInteger
      end
      item
        Name = 'quantity'
        DataType = ftFloat
      end
      item
        Name = 'price'
        DataType = ftFloat
      end
      item
        Name = 'unit1qty'
        DataType = ftFloat
      end
      item
        Name = 'unit2qty'
        DataType = ftFloat
      end
      item
        Name = 'unit3qty'
        DataType = ftFloat
      end
      item
        Name = 'assqty'
        DataType = ftFloat
      end
      item
        Name = 'relationassqty'
        DataType = ftFloat
      end
      item
        Name = 'batchcode'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'productdate'
        DataType = ftDateTime
      end
      item
        Name = 'validdate'
        DataType = ftDateTime
      end
      item
        Name = 'relationcount'
        DataType = ftSmallint
      end
      item
        Name = 'relationbtype'
        DataType = ftInteger
      end
      item
        Name = 'relationbid'
        DataType = ftInteger
      end
      item
        Name = 'relationbno'
        DataType = ftInteger
      end
      item
        Name = 'relationqty'
        DataType = ftFloat
      end
      item
        Name = 'custom1'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'custom2'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'custom3'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'custom4'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'custom5'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'custom6'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'custom7'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'custom8'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'custom9'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'custom10'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'explan'
        DataType = ftString
        Size = 200
      end
      item
        Name = 'balancedate'
        DataType = ftDateTime
      end
      item
        Name = 'pause'
        DataType = ftBoolean
      end
      item
        Name = 'grelationqty'
        DataType = ftFloat
      end
      item
        Name = 'grelationassqty'
        DataType = ftFloat
      end
      item
        Name = 'create_time'
        DataType = ftDateTime
      end
      item
        Name = 'custom11'
        DataType = ftFloat
      end
      item
        Name = 'custom12'
        DataType = ftFloat
      end
      item
        Name = 'custom13'
        DataType = ftFloat
      end
      item
        Name = 'custom14'
        DataType = ftFloat
      end
      item
        Name = 'custom15'
        DataType = ftFloat
      end
      item
        Name = 'p_code'
        DataType = ftString
        Size = 40
      end
      item
        Name = 'p_name'
        DataType = ftWideString
        Size = 60
      end
      item
        Name = 'p_spec'
        DataType = ftWideString
        Size = 60
      end
      item
        Name = 'unitname'
        DataType = ftWideString
        Size = 40
      end
      item
        Name = 'p_custom1'
        DataType = ftString
        Size = 100
      end
      item
        Name = 'p_custom2'
        DataType = ftString
        Size = 100
      end
      item
        Name = 'p_custom3'
        DataType = ftString
        Size = 100
      end
      item
        Name = 'P_custom4'
        DataType = ftString
        Size = 100
      end
      item
        Name = 'p_custom5'
        DataType = ftString
        Size = 100
      end
      item
        Name = 'p_custom6'
        DataType = ftString
        Size = 100
      end
      item
        Name = 'p_custom7'
        DataType = ftString
        Size = 100
      end
      item
        Name = 'p_custom8'
        DataType = ftString
        Size = 100
      end
      item
        Name = 'p_custom9'
        DataType = ftString
        Size = 100
      end
      item
        Name = 'p_custom10'
        DataType = ftString
        Size = 100
      end
      item
        Name = 'abname'
        DataType = ftWideString
        Size = 60
      end
      item
        Name = 'depotid_1'
        DataType = ftInteger
      end
      item
        Name = 'baseunitname'
        DataType = ftWideString
        Size = 40
      end
      item
        Name = 'unitassname'
        DataType = ftWideString
        Size = 40
      end
      item
        Name = 'unitrate'
        DataType = ftFloat
      end
      item
        Name = 'unitbarcode'
        DataType = ftWideString
        Size = 40
      end
      item
        Name = 'allqty'
        Attributes = [faReadonly]
        DataType = ftWideString
        Size = 200
      end>
    StoreDefs = True
  end
  inherited qryDetail: TUniQuery
    SQL.Strings = (
      
        'select d.*, p.code as p_code, p.name as p_name, p.spec as p_spec' +
        ', u.unitname as unitname,     '
      
        '    p.custom1 as p_custom1, p.custom2 as p_custom2, p.custom3 as' +
        ' p_custom3, p.custom4 as P_custom4,     '
      
        '    p.custom5 as p_custom5, p.custom6 as p_custom6, p.custom7 as' +
        ' p_custom7, p.custom8 as p_custom8,     '
      
        '    p.custom9 as p_custom9, p.custom10 as p_custom10, p.abname, ' +
        'p.depotid,                              '
      
        '    t.unitname as baseunitname,l.unitname as unitassname,u.rate ' +
        'as unitrate, u.barcode unitbarcode,     '
      
        '    dbo.f_getallqty(d.productid,d.unit1qty,d.unit2qty,d.unit3qty' +
        ') as allqty                             '
      
        '    from tb_purrequestdtl d left join td_product   p on d.produc' +
        'tid=p.p_id                          '
      
        '                            left join td_unitprice u on (d.produ' +
        'ctid=u.productid and u.unitid=d.unitid) '
      
        '                            left join td_unitprice t on (d.produ' +
        'ctid=t.productid and t.baseunit=1)      '
      
        '                            left join td_unitprice l on (d.produ' +
        'ctid=l.productid and l.u_no=0)          '
      '    where d.bid=0 order by borderno')
  end
  inherited MainDataSet: TUniQuery
    Left = 40
    Top = 209
  end
end
